-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
IF EXISTS (SELECT name FROM sysobjects 
         WHERE name = 'InsertMetaKeyword' AND type = 'P')
   DROP PROCEDURE InsertMetaKeyword
GO

CREATE PROCEDURE InsertMetaKeyword 
	-- Add the parameters for the stored procedure here
	(
		@Keyword nvarchar(max),
		@WebpageID int	
	)
AS
BEGIN

	declare @MetaID int
	
	exec GetMetaKeywordID @Word = @Keyword, @ID = @MetaID output
	
	IF (@MetaID = 0)
	BEGIN
		-------Find id to insert new record to database-------
		declare @id int

		select @id = max(ID) + 1
		from MetaKeywords
		if (@id is null)
		begin
			set @id = 1
		end

		------------------------------------------------------

		INSERT INTO MetaKeywords
			([ID],[Keyword],[Count])
		VALUES
			(@id, UPPER(@Keyword),0)
		
		SET @MetaID = @id
	END
	
	declare @count int
	select @count = [Count]
	from MetaKeywords
	where [ID] = @MetaID

	update MetaKeywords 
	set [Count] = @count + 1
	where [ID] = @MetaID

	declare @Comma int

	select @Comma = charindex(',',MetaKeywords)
	from Webpage
	where ID = @WebpageID

	if (@Comma > 0)
	begin
		declare @KeywordList varchar(MAX)
		select @KeywordList = MetaKeywords
		from Webpage
		where ID = @WebpageID

		update Webpage
		set [MetaKeywords] = @KeywordList + CAST(@MetaID as varchar(MAX)) + ','
		where ID = @WebpageID
	end
	else
	begin
		update Webpage
		set [MetaKeywords] = CAST(@MetaID as varchar(MAX)) + ','
		where ID = @WebpageID
	end
	
END
GO
